﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DDLParser.constant
{
    static class SqlServerDataType
    {
        public const int INT = DataType.INT;
        public const int REAL = DataType.DECIMAL;
        public const int DECIMAL = DataType.DECIMAL;
        public const int FLOAT = DataType.DECIMAL;
        public const int NUMERIC = DataType.INT;
        public const int MONEY = DataType.DECIMAL;
        public const int SMALLMONEY = DataType.DECIMAL;


        public const int CHAR = DataType.CHAR;
        public const int TEXT = DataType.STRING;
        public const int NCHAR = DataType.STRING;
        public const int NTEXT = DataType.STRING;
        public const int VARCHAR = DataType.STRING;
        public const int NVARCHAR = DataType.STRING;
        public const int STRING = DataType.STRING;

        public const int DATE = DataType.DATETIME;
        public const int DATETIME = DataType.DATETIME;
        public const int SMALLDATETIME = DataType.DATETIME;
        public const int DATETIMEOFFSET = DataType.DATETIME;

        public const int TIME = DataType.DATETIME;
        public const int TIMESTAMP = DataType.DATETIME;

        public const int IMAGE = DataType.IMAGE;
        public const int GEOGRAPHY = DataType.GEOLOCATION;
        public const int GEOMETRY = DataType.STRING;

        public const int HIERARCHYID = DataType.INT;

        public const int BIGINT = DataType.INT;
        public const int SMALLINT = DataType.INT;
        public const int TINYINT = DataType.INT;

        public const int BOOLEAN = DataType.BOOLEAN;
        public const int BIT = DataType.BOOLEAN;

        public const int BINARY = DataType.STRING;
        public const int VARBINARY = DataType.STRING;

        public const int UNIQUEIDENTIFIER = DataType.STRING;
        public const int SQLVARIANT = DataType.STRING;
        public const int XML = DataType.STRING;
        
    }
}
